MAT_VIEW REWRITE ACCESS FULL
Short Description
Uses a materialized view to retrieve all rows.
Detailed Description​
Materialised views are commonly used for frequently accessed subsets of data as with a normal view the source data would have to be read for each access. A materialised view hold a point in time copy of the source data, therefore may not be fully up to date.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.